﻿CREATE TABLE [dbo].[arhParteneri] (
    [IDPartener]                 BIGINT          NOT NULL,
    [CUI]                        DECIMAL (13)    NOT NULL,
    [Denumire]                   VARCHAR (200)   NOT NULL,
    [IDBanca]                    SMALLINT        NOT NULL,
    [ContBancar]                 VARCHAR (50)    NOT NULL,
    [Cont]                       VARCHAR (50)    NOT NULL,
    [CodUnitate]                 SMALLINT        NOT NULL,
    [TipPartener]                VARCHAR (50)    NOT NULL,
    [IDJudet]                    INT             NOT NULL,
    [IDLocalitate]               INT             NOT NULL,
    [Strada]                     VARCHAR (50)    NULL,
    [Nr]                         VARCHAR (10)    NULL,
    [AtributFiscal]              VARCHAR (10)    NOT NULL,
    [JudetRegComert]             SMALLINT        NOT NULL,
    [NrRegComert]                INT             NOT NULL,
    [AnRegComert]                SMALLINT        NOT NULL,
    [NumeDelegat]                VARCHAR (50)    NOT NULL,
    [SerieAI]                    VARCHAR (5)     NOT NULL,
    [NrAI]                       VARCHAR (6)     NOT NULL,
    [MijlocTransport]            VARCHAR (50)    NOT NULL,
    [NrMijlocTransport]          VARCHAR (50)    NOT NULL,
    [CodPostal]                  VARCHAR (10)    NULL,
    [Telefon]                    VARCHAR (50)    NULL,
    [Fax]                        VARCHAR (50)    NULL,
    [ContClient]                 [dbo].[TipCont] NULL,
    [ConditiiDePlata]            VARCHAR (250)   NULL,
    [IDTara]                     INT             NULL,
    [IDContactDelegat]           INT             NULL,
    [IDMijlocTransport]          SMALLINT        NULL,
    [ScadentaFacturiClient]      INT             NULL,
    [ScadentaFacturiFurnizor]    INT             NULL,
    [ScadentaFacturiSfarsitLuna] BIT             NOT NULL,
    [An]                         SMALLINT        NOT NULL,
    CONSTRAINT [PK_arhFurnizori] PRIMARY KEY CLUSTERED ([IDPartener] ASC, [An] ASC)
);

